jdbc– c3p0xml 链接

c3p0xml 链接

 // 配置文件连接
    @Test
    public void c3p0Test02() throws SQLException {
        ComboPooledDataSource comboPooledDataSource = new ComboPooledDataSource("mysql");

        System.out.println("执行....");
        long start = System.currentTimeMillis();

        for (int i = 0; i < 5000; i++) {
            Connection connection = comboPooledDataSource.getConnection();
            connection.close();
        }
        System.out.println("执行时间"+(System.currentTimeMillis()-start));
    }

配置文件放src下 c3p0-config.xml

<c3p0-config >
  <named-config name="mysql">
  <property name="jdbcUrl">jdbc:mysql://127.0.0.1:3306/persons?rewriteBatchedStatements=true</property>
  <property name="driverClass">com.mysql.jdbc.Driver</property>
  <property name="user">root</property>
  <property name="password">123312</property>

  <property name="checkoutTimeout">3000</property>
  <property name="initialPoolSize">10</property>
  <property name="maxPoolSize">100</property>
  <property name="minPoolSize">10</property>
  <property name="maxStatements">200</property>
  <!--每次增长长度-->
  <property name="acquireIncrement">5</property>
  <!--每个对象命令数-->
  <property name="maxStatementsPerConnection">2</property>
  </named-config>
</c3p0-config>